Importing and exporting CSV files.
Importing entries from a CSV file.
|
To import data from CSV files, do the following: :
- Copy the file you want to import to the memento folder on the flash card.
- Open the library you want to import the entries to.
- Select the Settings item on the library menu.
- Press Import from CSV in the settings. You will see the list of CSV files in the memento folder. Select the one you need.
- After you select the file, you will see the list of columns found in the file which correspond to the entry fields.
- Press the Import button.
When you import data from CSV files, new entries are created each time.
|
CSV file format.
|
The name of a column must correspond to the name of an entry field.
The file must contain a column with the field that is the name of the entry.
Memento allows you to import only fields of certain types: text, integer, real number, date, date/time, rating, currency, string values, coordinate, boolean, hyperlink.
Data format notes:
Field type |
Format and notes |
Date |
The date must be in the same format as in the system settings. |
Date/Time |
The values are separated with a space, the date comes first and then comes time in the HH:MM format. |
String values |
The value being imported must already be in the parameters of the corresponding field. |
Boolean |
The following values are acceptable for the truth value: true, yes, 1 |
Coordinate |
latitude:longitude |
Rating |
A number from 0 to 5. |
Before you import entries, it is recommended to back up your libraries.
|
Exporting data to CSV
|
To export data to a CSV file, do the following:
- Open the library you want to export entries to a CSV file from.
- Select the Settings item on the library menu.
- Press Export to CSV in the settings.
- Enter the name of the CSV file and press the Export button.
- The file with data will be saved to the memento folder on the flash card.
|
|